Excel OLE dokumentacia - subtotals - souhrny
Otázka od: Jaroslav Popluhar
10. 12. 2003 14:02
Hello delphi-l,
Existuje niekde nejaka (kompletna?) dokumentacia k OLE rozhraniu
Excelu? Kde hladat?
Potreboval by som z Delphi naplnit Excelovsky subor datami
(to by som hadam este najako zvladol) a potom by mal
Delphi program zavolat
Data - Subtotals - Subtotal dlg (Data - Souhrny - Souhrny),
a nastavit parametre
"At each change in", "Use function", "Add subtotal to"
(U kazde zmeny ve sloupci, Pouzit funkci, Pridat souhrn do sloupce)
a check boxy
"Replace current subtotals", "Page break between groups",
"Summary
below data".
--
Best regards,
Jaroslav mailto:delphi1@acc.sk
Odpovedá: Bohac Frantisek
10. 12. 2003 16:05
> Existuje niekde nejaka (kompletna?) dokumentacia k OLE rozhraniu
> Excelu? Kde hladat?
http://msdn.microsoft.com
tady je dokumentace vseho mozneho. A nebo primo v Excelu - Editor Jazyka
Visual Basic - dej si Object Browser (F2) a nebo F1 pro napovedu.
S pozdravem
Frantisek Bohac
Odpovedá: Petr Brant
10. 12. 2003 16:28
Ahoj, mam VBAXL9.CHM, ma to asi 1.5 MB, jestli to chces poslat mailem, je
tam toho spousta, krome jineho i funkce Group a jak vidim, i metoda
SubTotal, pise se k ni toto, snad je to ono:
Creates subtotals for the range (or the current region, if the range is a
single cell).
Syntax
expression.Subtotal(GroupBy, Function, TotalList, Replace, PageBreaks,
SummaryBelowData)
expression Required. An expression that returns a Range object.
GroupBy Required Long. The field to group by, as a 1-based integer offset.
For more information, see the example.
Function Required Long. The subtotal function. Can be one of the following
XlConsolidationFunction constants: xlAverage, xlCount, xlCountNums, xlMax,
xlMin, xlProduct, xlStDev, xlStDevP, xlSum, xlVar, or xlVarP.
TotalList Required Variant. An array of 1-based field offsets, indicating
the fields to which the subtotals are added. For more information, see the
example.
Replace Optional Variant. True to replace existing subtotals. The default
value is False.
PageBreaks Optional Variant. True to add page breaks after each group. The
default value is False.
SummaryBelowData Optional Variant. Can be one of the following xlSummaryRow
constants: xlSummaryAbove or xlSummaryBelow. The default value is
xlSummaryBelow.
Tak jestli to chces, napis na soukromy mail a muzu ti to poslat.
RNDr. Petr Brant [brant@dcomm.cz]
http://web.redbox.cz/petr.brant
Existuje niekde nejaka (kompletna?) dokumentacia k OLE rozhraniu
Excelu? Kde hladat?
Potreboval by som z Delphi naplnit Excelovsky subor datami
(to by som hadam este najako zvladol) a potom by mal
Delphi program zavolat
Data - Subtotals - Subtotal dlg (Data - Souhrny - Souhrny),
a nastavit parametre
"At each change in", "Use function", "Add subtotal to"
(U kazde zmeny ve sloupci, Pouzit funkci, Pridat souhrn do
sloupce)
a check boxy
"Replace current subtotals", "Page break between groups",
"Summary
below data".
Odpovedá: Jaroslav Popluhar
11. 12. 2003 2:05
Hello Petr,
Wednesday, December 10, 2003, 4:14:13 PM, you wrote:
PB> Ahoj, mam VBAXL9.CHM, ma to asi 1.5 MB, jestli to chces poslat mailem, je
PB> tam toho spousta, krome jineho i funkce Group a jak vidim, i metoda
PB> SubTotal, pise se k ni toto, snad je to ono:
Diky, zistil som, ze VBAXLn.CHM je v instalcii Excelu.
Pre XP je n = 10
--
Best regards,
Jaroslav mailto:delphi1@acc.sk